[dbo].[BAEEventSetupGetFunctionQuestions]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventSetupGetFunctionQuestions

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(16)	16
@functionCode	varchar(16)	16

SQL Script

create procedure [dbo].[BAEEventSetupGetFunctionQuestions] @eventCode varchar(16),
     @functionCode varchar(16) as
SELECT *, UPPER(FunctionCode) + '      ' + Question EventQuestion  FROM EventSetupQuestion
    WHERE UPPER(EventCode) = UPPER(@eventCode) AND UPPER(FunctionCode) = UPPER(@functionCode)
    ORDER BY QuestionOrder

GO

Uses

[dbo].[EventSetupQuestion]
dbo